Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 1532 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 149.6 KiB |
| Average record size in memory | 100.0 B |
Variable types
| Numeric | 12 |
|---|
gross_revenue is highly overall correlated with recency_days and 4 other fields | High correlation |
recency_days is highly overall correlated with gross_revenue and 2 other fields | High correlation |
invoice_no is highly overall correlated with gross_revenue and 4 other fields | High correlation |
qtde_items is highly overall correlated with gross_revenue and 5 other fields | High correlation |
qtde_produto is highly overall correlated with gross_revenue and 3 other fields | High correlation |
avg_ticket is highly overall correlated with avg_unique_basket_size | High correlation |
frequency is highly overall correlated with gross_revenue and 2 other fields | High correlation |
avg_basket_size is highly overall correlated with qtde_items | High correlation |
avg_unique_basket_size is highly overall correlated with qtde_produto and 1 other fields | High correlation |
avg_ticket is highly skewed (γ1 = 38.61887027) | Skewed |
frequency is highly skewed (γ1 = 36.9526308) | Skewed |
qtde_returns is highly skewed (γ1 = 37.17310928) | Skewed |
avg_basket_size is highly skewed (γ1 = 34.54413707) | Skewed |
customer_id has unique values | Unique |
recency_days has 25 (1.6%) zeros | Zeros |
frequency has 199 (13.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-06-22 12:30:45.560792 |
|---|---|
| Analysis finished | 2023-06-22 12:31:44.757255 |
| Duration | 59.2 seconds |
| Software version | ydata-profiling vv4.1.0 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
| Distinct | 1532 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15178.853 |
| Minimum | 12352 |
|---|---|
| Maximum | 18282 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 18.0 KiB |
Quantile statistics
| Minimum | 12352 |
|---|---|
| 5-th percentile | 12592.2 |
| Q1 | 13716.5 |
| median | 15123.5 |
| Q3 | 16657 |
| 95-th percentile | 17950.45 |
| Maximum | 18282 |
| Range | 5930 |
| Interquartile range (IQR) | 2940.5 |
Descriptive statistics
| Standard deviation | 1716.7544 |
|---|---|
| Coefficient of variation (CV) | 0.11310172 |
| Kurtosis | -1.1716387 |
| Mean | 15178.853 |
| Median Absolute Deviation (MAD) | 1487.5 |
| Skewness | 0.093211119 |
| Sum | 23254003 |
| Variance | 2947245.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17850 | 1 | 0.1% |
| 15249 | 1 | 0.1% |
| 15521 | 1 | 0.1% |
| 12456 | 1 | 0.1% |
| 13588 | 1 | 0.1% |
| 12888 | 1 | 0.1% |
| 16253 | 1 | 0.1% |
| 15906 | 1 | 0.1% |
| 17719 | 1 | 0.1% |
| 17874 | 1 | 0.1% |
| Other values (1522) | 1522 |
| Value | Count | Frequency (%) |
| 12352 | 1 | |
| 12359 | 1 | |
| 12362 | 1 | |
| 12375 | 1 | |
| 12379 | 1 | |
| 12380 | 1 | |
| 12381 | 1 | |
| 12383 | 1 | |
| 12384 | 1 | |
| 12395 | 1 |
| Value | Count | Frequency (%) |
| 18282 | 1 | |
| 18277 | 1 | |
| 18276 | 1 | |
| 18274 | 1 | |
| 18272 | 1 | |
| 18270 | 1 | |
| 18269 | 1 | |
| 18263 | 1 | |
| 18260 | 1 | |
| 18257 | 1 |
gross_revenue
Real number (ℝ)
| Distinct | 1530 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4236.1385 |
| Minimum | 6.2 |
|---|---|
| Maximum | 280206.02 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 6.2 |
|---|---|
| 5-th percentile | 263.876 |
| Q1 | 731.31 |
| median | 1604.37 |
| Q3 | 3502.7525 |
| 95-th percentile | 11102.388 |
| Maximum | 280206.02 |
| Range | 280199.82 |
| Interquartile range (IQR) | 2771.4425 |
Descriptive statistics
| Standard deviation | 14620.496 |
|---|---|
| Coefficient of variation (CV) | 3.4513735 |
| Kurtosis | 184.30578 |
| Mean | 4236.1385 |
| Median Absolute Deviation (MAD) | 1052.26 |
| Skewness | 12.178236 |
| Sum | 6489764.2 |
| Variance | 2.1375891 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1353.74 | 2 | 0.1% |
| 63 | 2 | 0.1% |
| 5391.21 | 1 | 0.1% |
| 683.46 | 1 | 0.1% |
| 2446.6 | 1 | 0.1% |
| 3000.2 | 1 | 0.1% |
| 3181.04 | 1 | 0.1% |
| 2478.95 | 1 | 0.1% |
| 354.12 | 1 | 0.1% |
| 3683.86 | 1 | 0.1% |
| Other values (1520) | 1520 |
| Value | Count | Frequency (%) |
| 6.2 | 1 | |
| 6.9 | 1 | |
| 13.3 | 1 | |
| 15 | 1 | |
| 52.2 | 1 | |
| 63 | 2 | |
| 71.4 | 1 | |
| 76.5 | 1 | |
| 85 | 1 | |
| 89.2 | 1 |
| Value | Count | Frequency (%) |
| 280206.02 | 1 | |
| 259657.3 | 1 | |
| 194550.79 | 1 | |
| 168472.5 | 1 | |
| 143825.06 | 1 | |
| 124914.53 | 1 | |
| 117379.63 | 1 | |
| 91062.38 | 1 | |
| 81024.84 | 1 | |
| 66653.56 | 1 |
recency_days
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 239 |
|---|---|
| Distinct (%) | 15.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.994125 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 25 |
| Zeros (%) | 1.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 10 |
| median | 28 |
| Q3 | 77 |
| 95-th percentile | 266.9 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 67 |
Descriptive statistics
| Standard deviation | 83.87148 |
|---|---|
| Coefficient of variation (CV) | 1.3106122 |
| Kurtosis | 2.8444643 |
| Mean | 63.994125 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | 1.8783408 |
| Sum | 98039 |
| Variance | 7034.4252 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 63 | 4.1% |
| 2 | 58 | 3.8% |
| 8 | 50 | 3.3% |
| 3 | 49 | 3.2% |
| 4 | 47 | 3.1% |
| 22 | 36 | 2.3% |
| 17 | 35 | 2.3% |
| 16 | 34 | 2.2% |
| 7 | 34 | 2.2% |
| 10 | 34 | 2.2% |
| Other values (229) | 1092 |
| Value | Count | Frequency (%) |
| 0 | 25 | 1.6% |
| 1 | 63 | |
| 2 | 58 | |
| 3 | 49 | |
| 4 | 47 | |
| 5 | 21 | 1.4% |
| 7 | 34 | |
| 8 | 50 | |
| 9 | 30 | |
| 10 | 34 |
| Value | Count | Frequency (%) |
| 373 | 2 | |
| 372 | 4 | |
| 371 | 1 | 0.1% |
| 368 | 1 | 0.1% |
| 366 | 3 | |
| 365 | 3 | |
| 364 | 1 | 0.1% |
| 360 | 1 | 0.1% |
| 359 | 1 | 0.1% |
| 358 | 3 |
invoice_no
Real number (ℝ)
| Distinct | 58 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.5339426 |
| Minimum | 1 |
|---|---|
| Maximum | 209 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 22 |
| Maximum | 209 |
| Range | 208 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 11.806718 |
|---|---|
| Coefficient of variation (CV) | 1.5671367 |
| Kurtosis | 116.24442 |
| Mean | 7.5339426 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 8.590718 |
| Sum | 11542 |
| Variance | 139.39859 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2 | 208 | |
| 1 | 193 | |
| 3 | 188 | |
| 4 | 172 | |
| 5 | 128 | |
| 6 | 103 | 6.7% |
| 7 | 89 | 5.8% |
| 8 | 71 | 4.6% |
| 9 | 53 | 3.5% |
| 10 | 39 | 2.5% |
| Other values (48) | 288 |
| Value | Count | Frequency (%) |
| 1 | 193 | |
| 2 | 208 | |
| 3 | 188 | |
| 4 | 172 | |
| 5 | 128 | |
| 6 | 103 | |
| 7 | 89 | |
| 8 | 71 | 4.6% |
| 9 | 53 | 3.5% |
| 10 | 39 | 2.5% |
| Value | Count | Frequency (%) |
| 209 | 1 | |
| 201 | 1 | |
| 124 | 1 | |
| 97 | 1 | |
| 93 | 1 | |
| 91 | 1 | |
| 86 | 1 | |
| 73 | 1 | |
| 63 | 1 | |
| 62 | 1 |
qtde_items
Real number (ℝ)
| Distinct | 1189 |
|---|---|
| Distinct (%) | 77.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2385.0777 |
| Minimum | 1 |
|---|---|
| Maximum | 196915 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 108 |
| Q1 | 383.75 |
| median | 911 |
| Q3 | 1966 |
| 95-th percentile | 6173.25 |
| Maximum | 196915 |
| Range | 196914 |
| Interquartile range (IQR) | 1582.25 |
Descriptive statistics
| Standard deviation | 8031.4735 |
|---|---|
| Coefficient of variation (CV) | 3.3673845 |
| Kurtosis | 255.02823 |
| Mean | 2385.0777 |
| Median Absolute Deviation (MAD) | 627 |
| Skewness | 13.329693 |
| Sum | 3653939 |
| Variance | 64504567 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 73 | 5 | 0.3% |
| 114 | 5 | 0.3% |
| 416 | 5 | 0.3% |
| 288 | 5 | 0.3% |
| 544 | 4 | 0.3% |
| 76 | 4 | 0.3% |
| 371 | 4 | 0.3% |
| 91 | 4 | 0.3% |
| 140 | 4 | 0.3% |
| 800 | 4 | 0.3% |
| Other values (1179) | 1488 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 12 | 2 | |
| 16 | 1 | |
| 18 | 1 | |
| 23 | 1 | |
| 26 | 1 | |
| 28 | 2 | |
| 29 | 1 |
| Value | Count | Frequency (%) |
| 196915 | 1 | |
| 80997 | 1 | |
| 80265 | 1 | |
| 77374 | 1 | |
| 69993 | 1 | |
| 64549 | 1 | |
| 64124 | 1 | |
| 63312 | 1 | |
| 58343 | 1 | |
| 57885 | 1 |
qtde_produto
Real number (ℝ)
| Distinct | 305 |
|---|---|
| Distinct (%) | 19.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 94.57376 |
| Minimum | 1 |
|---|---|
| Maximum | 1787 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 29 |
| median | 65 |
| Q3 | 117 |
| 95-th percentile | 277 |
| Maximum | 1787 |
| Range | 1786 |
| Interquartile range (IQR) | 88 |
Descriptive statistics
| Standard deviation | 119.46902 |
|---|---|
| Coefficient of variation (CV) | 1.2632364 |
| Kurtosis | 65.180771 |
| Mean | 94.57376 |
| Median Absolute Deviation (MAD) | 41 |
| Skewness | 6.0623329 |
| Sum | 144887 |
| Variance | 14272.846 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 14 | 23 | 1.5% |
| 24 | 21 | 1.4% |
| 25 | 20 | 1.3% |
| 11 | 20 | 1.3% |
| 20 | 19 | 1.2% |
| 30 | 18 | 1.2% |
| 17 | 18 | 1.2% |
| 34 | 17 | 1.1% |
| 66 | 17 | 1.1% |
| 19 | 17 | 1.1% |
| Other values (295) | 1342 |
| Value | Count | Frequency (%) |
| 1 | 11 | |
| 2 | 4 | 0.3% |
| 3 | 7 | |
| 4 | 10 | |
| 5 | 14 | |
| 6 | 11 | |
| 7 | 11 | |
| 8 | 16 | |
| 9 | 14 | |
| 10 | 13 |
| Value | Count | Frequency (%) |
| 1787 | 1 | |
| 1768 | 1 | |
| 1323 | 1 | |
| 1119 | 1 | |
| 884 | 1 | |
| 819 | 1 | |
| 718 | 1 | |
| 714 | 1 | |
| 700 | 1 | |
| 636 | 1 |
avg_ticket
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 1531 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 73.05008 |
| Minimum | 3.1 |
|---|---|
| Maximum | 56157.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 3.1 |
|---|---|
| 5-th percentile | 6.4187828 |
| Q1 | 15.507449 |
| median | 19.133254 |
| Q3 | 26.727426 |
| 95-th percentile | 94.740328 |
| Maximum | 56157.5 |
| Range | 56154.4 |
| Interquartile range (IQR) | 11.219978 |
Descriptive statistics
| Standard deviation | 1440.5126 |
|---|---|
| Coefficient of variation (CV) | 19.719521 |
| Kurtosis | 1503.7584 |
| Mean | 73.05008 |
| Median Absolute Deviation (MAD) | 4.8695923 |
| Skewness | 38.61887 |
| Sum | 111912.72 |
| Variance | 2075076.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16.83333333 | 2 | 0.1% |
| 21.46140351 | 1 | 0.1% |
| 25.44832 | 1 | 0.1% |
| 14.24683908 | 1 | 0.1% |
| 70.824 | 1 | 0.1% |
| 29.9500813 | 1 | 0.1% |
| 10.45126667 | 1 | 0.1% |
| 19.69357664 | 1 | 0.1% |
| 14.85782609 | 1 | 0.1% |
| 18.1272973 | 1 | 0.1% |
| Other values (1521) | 1521 |
| Value | Count | Frequency (%) |
| 3.1 | 1 | |
| 3.140802469 | 1 | |
| 3.157113402 | 1 | |
| 3.45 | 1 | |
| 3.487294118 | 1 | |
| 3.734567219 | 1 | |
| 3.823875969 | 1 | |
| 3.831937173 | 1 | |
| 3.864423077 | 1 | |
| 3.875769231 | 1 |
| Value | Count | Frequency (%) |
| 56157.5 | 1 | |
| 4453.43 | 1 | |
| 2027.86 | 1 | |
| 952.9875 | 1 | |
| 931.5 | 1 | |
| 835.864 | 1 | |
| 643.8585714 | 1 | |
| 602.4531323 | 1 | |
| 577.3020475 | 1 | |
| 512.877561 | 1 |
avg_recency_days
Real number (ℝ)
| Distinct | 899 |
|---|---|
| Distinct (%) | 58.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.395509 |
| Minimum | 1 |
|---|---|
| Maximum | 362 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 19.444444 |
| median | 35 |
| Q3 | 57.541667 |
| 95-th percentile | 111 |
| Maximum | 362 |
| Range | 361 |
| Interquartile range (IQR) | 38.097222 |
Descriptive statistics
| Standard deviation | 39.700919 |
|---|---|
| Coefficient of variation (CV) | 0.89425529 |
| Kurtosis | 14.194427 |
| Mean | 44.395509 |
| Median Absolute Deviation (MAD) | 17.821429 |
| Skewness | 2.9290172 |
| Sum | 68013.921 |
| Variance | 1576.163 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 20 | 1.3% |
| 6 | 15 | 1.0% |
| 7 | 14 | 0.9% |
| 5 | 13 | 0.8% |
| 1 | 13 | 0.8% |
| 14 | 12 | 0.8% |
| 8 | 12 | 0.8% |
| 3 | 11 | 0.7% |
| 21 | 10 | 0.7% |
| 28 | 10 | 0.7% |
| Other values (889) | 1402 |
| Value | Count | Frequency (%) |
| 1 | 13 | |
| 1.5 | 1 | 0.1% |
| 2 | 10 | |
| 2.5 | 1 | 0.1% |
| 2.565517241 | 1 | 0.1% |
| 3 | 11 | |
| 3.271929825 | 1 | 0.1% |
| 3.321428571 | 1 | 0.1% |
| 3.5 | 2 | 0.1% |
| 4 | 20 |
| Value | Count | Frequency (%) |
| 362 | 1 | |
| 351 | 1 | |
| 324 | 1 | |
| 309 | 1 | |
| 293 | 1 | |
| 292 | 1 | |
| 288 | 1 | |
| 285 | 1 | |
| 266 | 1 | |
| 260 | 1 |
frequency
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 883 |
|---|---|
| Distinct (%) | 57.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.065215058 |
| Minimum | 0 |
|---|---|
| Maximum | 34 |
| Zeros | 199 |
| Zeros (%) | 13.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.014482282 |
| median | 0.024169184 |
| Q3 | 0.041124116 |
| 95-th percentile | 0.1 |
| Maximum | 34 |
| Range | 34 |
| Interquartile range (IQR) | 0.026641834 |
Descriptive statistics
| Standard deviation | 0.88606993 |
|---|---|
| Coefficient of variation (CV) | 13.586892 |
| Kurtosis | 1409.0501 |
| Mean | 0.065215058 |
| Median Absolute Deviation (MAD) | 0.012229437 |
| Skewness | 36.952631 |
| Sum | 99.909468 |
| Variance | 0.78511991 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 199 | 13.0% |
| 0.07142857143 | 9 | 0.6% |
| 0.01923076923 | 8 | 0.5% |
| 0.0303030303 | 7 | 0.5% |
| 0.025 | 6 | 0.4% |
| 0.01960784314 | 6 | 0.4% |
| 0.02127659574 | 6 | 0.4% |
| 0.02380952381 | 6 | 0.4% |
| 0.02325581395 | 6 | 0.4% |
| 0.02197802198 | 6 | 0.4% |
| Other values (873) | 1273 |
| Value | Count | Frequency (%) |
| 0 | 199 | |
| 0.005494505495 | 1 | 0.1% |
| 0.005698005698 | 1 | 0.1% |
| 0.005730659026 | 1 | 0.1% |
| 0.005847953216 | 1 | 0.1% |
| 0.005917159763 | 1 | 0.1% |
| 0.005970149254 | 2 | 0.1% |
| 0.006024096386 | 1 | 0.1% |
| 0.006472491909 | 1 | 0.1% |
| 0.006535947712 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 34 | 1 | |
| 6 | 1 | |
| 2 | 2 | |
| 1.333333333 | 1 | |
| 1 | 2 | |
| 0.5603217158 | 1 | |
| 0.5403225806 | 1 | |
| 0.5 | 2 | |
| 0.3333333333 | 2 | |
| 0.2857142857 | 2 |
qtde_returns
Real number (ℝ)
| Distinct | 216 |
|---|---|
| Distinct (%) | 14.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 123.21932 |
| Minimum | 1 |
|---|---|
| Maximum | 80995 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 9 |
| Q3 | 26 |
| 95-th percentile | 234.45 |
| Maximum | 80995 |
| Range | 80994 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 2105.2918 |
|---|---|
| Coefficient of variation (CV) | 17.085728 |
| Kurtosis | 1425.157 |
| Mean | 123.21932 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 37.173109 |
| Sum | 188772 |
| Variance | 4432253.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 183 | 11.9% |
| 2 | 153 | 10.0% |
| 3 | 107 | 7.0% |
| 4 | 90 | 5.9% |
| 6 | 72 | 4.7% |
| 5 | 64 | 4.2% |
| 8 | 49 | 3.2% |
| 12 | 48 | 3.1% |
| 7 | 47 | 3.1% |
| 9 | 38 | 2.5% |
| Other values (206) | 681 |
| Value | Count | Frequency (%) |
| 1 | 183 | |
| 2 | 153 | |
| 3 | 107 | |
| 4 | 90 | |
| 5 | 64 | 4.2% |
| 6 | 72 | 4.7% |
| 7 | 47 | 3.1% |
| 8 | 49 | 3.2% |
| 9 | 38 | 2.5% |
| 10 | 34 | 2.2% |
| Value | Count | Frequency (%) |
| 80995 | 1 | |
| 9014 | 1 | |
| 8060 | 1 | |
| 4627 | 1 | |
| 3768 | 1 | |
| 3335 | 1 | |
| 2975 | 1 | |
| 2022 | 1 | |
| 2012 | 1 | |
| 1920 | 1 |
avg_basket_size
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 1275 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 291.14577 |
| Minimum | 1 |
|---|---|
| Maximum | 40498.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 51.3875 |
| Q1 | 119.65179 |
| median | 194.05357 |
| Q3 | 304.59539 |
| 95-th percentile | 684.665 |
| Maximum | 40498.5 |
| Range | 40497.5 |
| Interquartile range (IQR) | 184.94361 |
Descriptive statistics
| Standard deviation | 1073.3752 |
|---|---|
| Coefficient of variation (CV) | 3.6867276 |
| Kurtosis | 1288.712 |
| Mean | 291.14577 |
| Median Absolute Deviation (MAD) | 88.363095 |
| Skewness | 34.544137 |
| Sum | 446035.32 |
| Variance | 1152134.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 114 | 6 | 0.4% |
| 288 | 5 | 0.3% |
| 190 | 5 | 0.3% |
| 86 | 5 | 0.3% |
| 82 | 5 | 0.3% |
| 208 | 4 | 0.3% |
| 185.5 | 4 | 0.3% |
| 80.5 | 4 | 0.3% |
| 298 | 4 | 0.3% |
| 88 | 4 | 0.3% |
| Other values (1265) | 1486 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 1.5 | 1 | |
| 2 | 1 | |
| 5.333333333 | 1 | |
| 6.142857143 | 1 | |
| 12 | 2 | |
| 13 | 1 | |
| 18 | 1 | |
| 19 | 1 | |
| 22 | 1 |
| Value | Count | Frequency (%) |
| 40498.5 | 1 | |
| 6009.333333 | 1 | |
| 3684.47619 | 1 | |
| 2697.465753 | 1 | |
| 2183.2 | 1 | |
| 2160.333333 | 1 | |
| 2141.5 | 1 | |
| 2082.225806 | 1 | |
| 1953.5 | 1 | |
| 1903.5 | 1 |
avg_unique_basket_size
Real number (ℝ)
| Distinct | 763 |
|---|---|
| Distinct (%) | 49.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.114881 |
| Minimum | 1 |
|---|---|
| Maximum | 300.64706 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4.0611111 |
| Q1 | 11 |
| median | 17.5 |
| Q3 | 26.6 |
| 95-th percentile | 55.534375 |
| Maximum | 300.64706 |
| Range | 299.64706 |
| Interquartile range (IQR) | 15.6 |
Descriptive statistics
| Standard deviation | 19.600326 |
|---|---|
| Coefficient of variation (CV) | 0.88629579 |
| Kurtosis | 36.330963 |
| Mean | 22.114881 |
| Median Absolute Deviation (MAD) | 7.4305556 |
| Skewness | 4.158966 |
| Sum | 33879.997 |
| Variance | 384.17277 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 29 | 1.9% |
| 14 | 24 | 1.6% |
| 11 | 21 | 1.4% |
| 20 | 19 | 1.2% |
| 17 | 18 | 1.2% |
| 5 | 17 | 1.1% |
| 21 | 17 | 1.1% |
| 9 | 16 | 1.0% |
| 18 | 16 | 1.0% |
| 10 | 16 | 1.0% |
| Other values (753) | 1339 |
| Value | Count | Frequency (%) |
| 1 | 15 | |
| 1.25 | 1 | 0.1% |
| 1.333333333 | 1 | 0.1% |
| 1.5 | 2 | 0.1% |
| 1.555555556 | 1 | 0.1% |
| 1.571428571 | 1 | 0.1% |
| 1.666666667 | 1 | 0.1% |
| 1.9 | 1 | 0.1% |
| 2 | 4 | 0.3% |
| 2.222222222 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 300.6470588 | 1 | |
| 203.5 | 1 | |
| 149 | 1 | |
| 136.25 | 1 | |
| 135.75 | 1 | |
| 127 | 1 | |
| 122 | 1 | |
| 110.3333333 | 1 | |
| 110 | 1 | |
| 109.4545455 | 1 |
| customer_id | gross_revenue | recency_days | invoice_no | qtde_items | qtde_produto | avg_ticket | avg_recency_days | frequency | qtde_returns | avg_basket_size | avg_unique_basket_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | -0.071 | -0.018 | 0.034 | -0.050 | -0.021 | -0.110 | 0.033 | 0.007 | -0.061 | -0.116 | -0.066 |
| gross_revenue | -0.071 | 1.000 | -0.534 | 0.826 | 0.942 | 0.729 | 0.227 | -0.141 | 0.551 | 0.388 | 0.485 | 0.264 |
| recency_days | -0.018 | -0.534 | 1.000 | -0.614 | -0.525 | -0.470 | 0.014 | 0.050 | -0.385 | -0.187 | -0.090 | -0.077 |
| invoice_no | 0.034 | 0.826 | -0.614 | 1.000 | 0.782 | 0.659 | 0.057 | -0.157 | 0.668 | 0.323 | 0.064 | 0.004 |
| qtde_items | -0.050 | 0.942 | -0.525 | 0.782 | 1.000 | 0.723 | 0.153 | -0.134 | 0.520 | 0.397 | 0.628 | 0.293 |
| qtde_produto | -0.021 | 0.729 | -0.470 | 0.659 | 0.723 | 1.000 | -0.371 | -0.031 | 0.420 | 0.227 | 0.352 | 0.689 |
| avg_ticket | -0.110 | 0.227 | 0.014 | 0.057 | 0.153 | -0.371 | 1.000 | -0.079 | 0.057 | 0.187 | 0.179 | -0.548 |
| avg_recency_days | 0.033 | -0.141 | 0.050 | -0.157 | -0.134 | -0.031 | -0.079 | 1.000 | -0.442 | -0.165 | -0.033 | 0.057 |
| frequency | 0.007 | 0.551 | -0.385 | 0.668 | 0.520 | 0.420 | 0.057 | -0.442 | 1.000 | 0.259 | 0.024 | -0.040 |
| qtde_returns | -0.061 | 0.388 | -0.187 | 0.323 | 0.397 | 0.227 | 0.187 | -0.165 | 0.259 | 1.000 | 0.228 | -0.009 |
| avg_basket_size | -0.116 | 0.485 | -0.090 | 0.064 | 0.628 | 0.352 | 0.179 | -0.033 | 0.024 | 0.228 | 1.000 | 0.485 |
| avg_unique_basket_size | -0.066 | 0.264 | -0.077 | 0.004 | 0.293 | 0.689 | -0.548 | 0.057 | -0.040 | -0.009 | 0.485 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| customer_id | gross_revenue | recency_days | invoice_no | qtde_items | qtde_produto | avg_ticket | avg_recency_days | frequency | qtde_returns | avg_basket_size | avg_unique_basket_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 17850 | 5391.21 | 372.0 | 34.0 | 1733.0 | 21.0 | 18.152222 | 35.500000 | 34.000000 | 40.0 | 50.970588 | 8.735294 |
| 1 | 13047 | 3237.54 | 31.0 | 10.0 | 1391.0 | 106.0 | 18.822907 | 26.307692 | 0.029240 | 36.0 | 139.100000 | 17.200000 |
| 2 | 12583 | 7281.38 | 2.0 | 15.0 | 5060.0 | 115.0 | 29.479271 | 21.823529 | 0.040431 | 51.0 | 337.333333 | 16.466667 |
| 4 | 15100 | 876.00 | 333.0 | 3.0 | 80.0 | 1.0 | 292.000000 | 8.600000 | 0.075000 | 22.0 | 26.666667 | 1.000000 |
| 5 | 15291 | 4668.30 | 25.0 | 15.0 | 2103.0 | 62.0 | 45.323301 | 21.750000 | 0.043103 | 29.0 | 140.200000 | 6.866667 |
| 6 | 14688 | 5630.87 | 7.0 | 21.0 | 3621.0 | 148.0 | 17.219786 | 18.300000 | 0.057377 | 399.0 | 172.428571 | 15.571429 |
| 7 | 17809 | 5411.91 | 16.0 | 12.0 | 2057.0 | 46.0 | 88.719836 | 32.454545 | 0.033613 | 42.0 | 171.416667 | 5.083333 |
| 8 | 15311 | 60767.90 | 0.0 | 91.0 | 38194.0 | 567.0 | 25.543464 | 4.144444 | 0.243968 | 474.0 | 419.714286 | 26.142857 |
| 9 | 14527 | 8508.82 | 2.0 | 55.0 | 2089.0 | 330.0 | 8.753930 | 5.888889 | 0.149864 | 40.0 | 37.981818 | 17.672727 |
| 13 | 16029 | 81024.84 | 38.0 | 63.0 | 40208.0 | 44.0 | 334.813388 | 7.613636 | 0.188060 | 8060.0 | 638.222222 | 3.841270 |
| customer_id | gross_revenue | recency_days | invoice_no | qtde_items | qtde_produto | avg_ticket | avg_recency_days | frequency | qtde_returns | avg_basket_size | avg_unique_basket_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5744 | 13832 | 52.20 | 19.0 | 1.0 | 28.0 | 3.0 | 17.400000 | 2.0 | 0.000000 | 3.0 | 28.000000 | 3.0 |
| 5758 | 18139 | 8438.34 | 17.0 | 6.0 | 5557.0 | 35.0 | 53.071321 | 1.0 | 6.000000 | 96.0 | 926.166667 | 26.5 |
| 5760 | 17010 | 195.36 | 18.0 | 1.0 | 118.0 | 11.0 | 17.760000 | 2.0 | 0.000000 | 2.0 | 118.000000 | 11.0 |
| 5770 | 16956 | 308.74 | 17.0 | 1.0 | 114.0 | 16.0 | 19.296250 | 8.0 | 0.000000 | 2.0 | 114.000000 | 16.0 |
| 5773 | 15877 | 493.28 | 1.0 | 2.0 | 371.0 | 122.0 | 3.823876 | 16.0 | 0.125000 | 125.0 | 185.500000 | 64.5 |
| 5785 | 16376 | 987.01 | 8.0 | 2.0 | 694.0 | 104.0 | 7.896080 | 9.0 | 0.222222 | 5.0 | 347.000000 | 62.5 |
| 5808 | 17727 | 1060.25 | 15.0 | 1.0 | 645.0 | 66.0 | 16.064394 | 6.0 | 0.000000 | 6.0 | 645.000000 | 66.0 |
| 5840 | 12479 | 527.20 | 11.0 | 1.0 | 385.0 | 31.0 | 17.006452 | 4.0 | 0.000000 | 34.0 | 385.000000 | 31.0 |
| 5861 | 14126 | 706.13 | 7.0 | 3.0 | 508.0 | 14.0 | 47.075333 | 3.0 | 1.000000 | 50.0 | 169.333333 | 5.0 |
| 5896 | 12558 | 269.96 | 7.0 | 1.0 | 196.0 | 11.0 | 24.541818 | 6.0 | 0.000000 | 196.0 | 196.000000 | 11.0 |